Distributed SQLite databases sacrifice consistency, transactions, and scalability. Traditional databases like PostgreSQL, paired with effective HTTP caching for speed, are better choices than using distributed SQLite. The upside to SQLite databases is that they are really fast, but at some point, the maintenance overhead outweighs the speed benefits.
Tuesday, April 9, 2024PLV8 is a trusted Javascript language extension for PostgreSQL. It can be used for stored procedures, triggers, etc.